/**
 *  iBizSys 5.0 机器人生产代码（不要直接修改当前代码）
 *  http://www.ibizsys.net
 */
package com.sa.ibiz.demo.srv.demo.demodel;



import net.ibizsys.paas.core.DEDataQuery;
import net.ibizsys.paas.core.DEDataQueryCodes;
import net.ibizsys.paas.core.DEDataQueryCode;
import net.ibizsys.paas.core.DEDataQueryCodeExp;
import net.ibizsys.paas.core.DEDataQueryCodeCond;

@DEDataQuery(id="951A9A7C-1F8E-4929-935C-894C84DD02D8",name="State40")
@DEDataQueryCodes({
    @DEDataQueryCode(querycode="SELECT t1.`AMOUNT`, t1.`CREATEDATE`, t1.`CREATEMAN`, t1.`DETAILNUM`, t1.`IBZ5CUSTOMERID`, t11.`IBZ5CUSTOMERNAME`, t1.`IBZ5ORDERID`, t1.`IBZ5ORDERNAME`, t1.`ORDERSTATE`, t1.`ORDERTIME`, t1.`ORDERTYPE`, t1.`ORDERUID`, t1.`UPDATEDATE`, t1.`UPDATEMAN` FROM `T_IBZ5ORDER` t1  LEFT JOIN T_IBZ5CUSTOMER t11 ON t1.IBZ5CUSTOMERID = t11.IBZ5CUSTOMERID  ",querycodetemp="SELECT t1.`AMOUNT`, t1.`CREATEDATE`, t1.`CREATEMAN`, t1.`DETAILNUM`, t1.`IBZ5CUSTOMERID`, t11.`IBZ5CUSTOMERNAME`, t1.`IBZ5ORDERID`, t1.`IBZ5ORDERNAME`, t1.`ORDERSTATE`, t1.`ORDERTIME`, t1.`ORDERTYPE`, t1.`ORDERUID`, t1.`UPDATEDATE`, t1.`UPDATEMAN` FROM `T_IBZ5ORDER_TMP` t1  LEFT JOIN T_IBZ5CUSTOMER t11 ON t1.IBZ5CUSTOMERID = t11.IBZ5CUSTOMERID  ",declarecode="",dbtype="MYSQL5",
    fieldexps={
        @DEDataQueryCodeExp(name="MEMO",expression="t1.`MEMO`")
        ,@DEDataQueryCodeExp(name="OPINION",expression="t1.`OPINION`")
        ,@DEDataQueryCodeExp(name="AMOUNT",expression="t1.`AMOUNT`")
        ,@DEDataQueryCodeExp(name="CREATEDATE",expression="t1.`CREATEDATE`")
        ,@DEDataQueryCodeExp(name="CREATEMAN",expression="t1.`CREATEMAN`")
        ,@DEDataQueryCodeExp(name="DETAILNUM",expression="t1.`DETAILNUM`")
        ,@DEDataQueryCodeExp(name="IBZ5CUSTOMERID",expression="t1.`IBZ5CUSTOMERID`")
        ,@DEDataQueryCodeExp(name="IBZ5CUSTOMERNAME",expression="t11.`IBZ5CUSTOMERNAME`")
        ,@DEDataQueryCodeExp(name="IBZ5ORDERID",expression="t1.`IBZ5ORDERID`")
        ,@DEDataQueryCodeExp(name="IBZ5ORDERNAME",expression="t1.`IBZ5ORDERNAME`")
        ,@DEDataQueryCodeExp(name="ORDERSTATE",expression="t1.`ORDERSTATE`")
        ,@DEDataQueryCodeExp(name="ORDERTIME",expression="t1.`ORDERTIME`")
        ,@DEDataQueryCodeExp(name="ORDERTYPE",expression="t1.`ORDERTYPE`")
        ,@DEDataQueryCodeExp(name="ORDERUID",expression="t1.`ORDERUID`")
        ,@DEDataQueryCodeExp(name="UPDATEDATE",expression="t1.`UPDATEDATE`")
        ,@DEDataQueryCodeExp(name="UPDATEMAN",expression="t1.`UPDATEMAN`")
    },
    conds={
        @DEDataQueryCodeCond(condition="( t1.`ORDERSTATE` = '40' )")
    })
})
/**
 *  实体数据查询 [审核状态为未通过]模型基类
 */
public class IBZ5ORDERState40DQModel extends net.ibizsys.paas.demodel.DEDataQueryModelBase {

    public IBZ5ORDERState40DQModel() {
        super();

        this.initAnnotation(IBZ5ORDERState40DQModel.class);
    }

}